UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dNO6f/9MnGWome9m7Mq1AWG7kmWIVgpOofuTeoac0e8='
WHERE
key_id = 'bc5dac92fa011b4ff0884a9c74ddef45803464d5625b78ea3f127ba78ccce852'
AND (
token = 'dNO6f/9MnGWome9m7Mq1AWG7kmWIVgpOofuTeoac0e8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)