UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HGStFcjrr5MXNlUDzZITjVKyftAuxpphYHPcgA43ZxI='
WHERE
key_id = '338c4671de03036fdf492547b51b44972990a3dcf2cf5a83d334b492f85f240f'
AND (
token = 'HGStFcjrr5MXNlUDzZITjVKyftAuxpphYHPcgA43ZxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)