UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2GXNj+AFhZHNP1DiHZtKP2PLtVjVVgBfoW+NghTEXMo='
WHERE
key_id = '02961bf28db904c8a578941ab8ac7af8855c0abca88d10eb65d99841c35a6cbc'
AND (
token = '2GXNj+AFhZHNP1DiHZtKP2PLtVjVVgBfoW+NghTEXMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)