UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bhZdqJl7pJ6wbiaK5DudZXMqSl9nyCi5h1hjr7uule0='
WHERE
key_id = 'ca3e4324b8bba496b813951fe18080f23f023765d5ba171d01f57d81b57af3f3'
AND (
token = 'bhZdqJl7pJ6wbiaK5DudZXMqSl9nyCi5h1hjr7uule0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)