UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Czdfd0FGeZJIWy41mn6JLJPEmnA2TbnW11Q9dh33so='
WHERE
key_id = '843b7bc1f6a5a5211a2f20fa4bb9596544f3a30dc2ed2606c445dc890f0a692b'
AND (
token = '6Czdfd0FGeZJIWy41mn6JLJPEmnA2TbnW11Q9dh33so='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)