UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9by3GjD8g7boYtDM6aWaW8OkdOS+3/hRYn2JXHLvB+Y='
WHERE
key_id = '6c47387c1e9352b3d236fe04c76733c3467d2db9c86607accf2b460b24f0478f'
AND (
token = '9by3GjD8g7boYtDM6aWaW8OkdOS+3/hRYn2JXHLvB+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)