UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+aDnXQEIMJsyL2X+I9ilL7ojGKDCAWft8e4W14jPTSA='
WHERE
key_id = 'a4c10684ee346a00267c3ae29f2ed1a9bda2f75d087e90606b328b371edef71b'
AND (
token = '+aDnXQEIMJsyL2X+I9ilL7ojGKDCAWft8e4W14jPTSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)