UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '31ZUCSDKCjOHXV8xjpLPXUsQH4OFQry6mF5BK4R6wlI='
WHERE
key_id = '178cfd21f1acffd52daa2ba3e41f86326282ee2b6d741d2343442b10398f9ffc'
AND (
token = '31ZUCSDKCjOHXV8xjpLPXUsQH4OFQry6mF5BK4R6wlI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)