UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4YmR8lS2Wd0nY4JhsmmYDPYOHFHAwReHB7XI3RIGsSw='
WHERE
key_id = 'fbc026b2eb45f67bb15eade69614535d5eac553b193249c6d78290853a744874'
AND (
token = '4YmR8lS2Wd0nY4JhsmmYDPYOHFHAwReHB7XI3RIGsSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)