UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T1gYJo3pf9PXkxF8U2OLN13xAJfXdGlO9KhxfrdJagw='
WHERE
key_id = '7ddfe30f63b55ecd52eed64dec342bca528419115255195c54e5118cfa13c533'
AND (
token = 'T1gYJo3pf9PXkxF8U2OLN13xAJfXdGlO9KhxfrdJagw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)