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