UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gTDBavcZgQ9VSupBQxOqZ04NQ/r7JNE8sNOxeO7jJV0='
WHERE
key_id = '2fbf6b57810e03c0d5cde96f0cd911a7a69456057277060ad3ca87565c84a36e'
AND (
token = 'gTDBavcZgQ9VSupBQxOqZ04NQ/r7JNE8sNOxeO7jJV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)