UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+dS390EWi9FP0XTx9H3NRPhE6PDo4n2hj2GO1tpFL+U='
WHERE
key_id = 'a7aefa211ddc04fee6aa95970f5ba1a35aaf1b8ab76ba23084ccd4c29db520e1'
AND (
token = '+dS390EWi9FP0XTx9H3NRPhE6PDo4n2hj2GO1tpFL+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)