UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7BPFyhpjN1luiAe6424X2UIh2zLCSuM3FFfZi5kUahQ='
WHERE
key_id = '3a26da93e9183696cf09ca00ac2c10d5f907cbf3552e4b365ac672341d8f35d1'
AND (
token = '7BPFyhpjN1luiAe6424X2UIh2zLCSuM3FFfZi5kUahQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)