UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sxgBL50788Kg/70CM/nUbz0riqLwenAA1ZJ0qb5cZWE='
WHERE
key_id = '80134312a405c4894f22ac05f0d8874cdc79f8fe080776da4f034f550ed4947a'
AND (
token = 'sxgBL50788Kg/70CM/nUbz0riqLwenAA1ZJ0qb5cZWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)