UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6dOWLffLzZxS0RyFCS0Tqx4ZW1+kTfRVn6p4QyNcOG8='
WHERE
key_id = '9867b943fd7b6b8a30ba8408af0513105fc4166a69455e93c36d8cdbe597ed87'
AND (
token = '6dOWLffLzZxS0RyFCS0Tqx4ZW1+kTfRVn6p4QyNcOG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)