UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9htViLB7nlVw9qvLzD6tvkvDmyaVu1OFSTHxPr6IKQc='
WHERE
key_id = '9aaa97b9e7a36b03b06b7d5cf7cba410b005eeb35a47eb04bda8c81aa0c9b2aa'
AND (
token = '9htViLB7nlVw9qvLzD6tvkvDmyaVu1OFSTHxPr6IKQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)