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