UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5PXCa7gDT94jiquRrX5PaESyKoNjEHIhN1K1sYFj9ds='
WHERE
key_id = 'cd8f9761923f25f71e9ef7e3e7155e7d3ef95b3f5d95918e38a755204c33673d'
AND (
token = '5PXCa7gDT94jiquRrX5PaESyKoNjEHIhN1K1sYFj9ds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)