UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vg2J02FrueAwiw+Lf/c2kfMFooAp+k5pBrcnzh0MP9Q='
WHERE
key_id = '42ca87c4f2b16ef3406fc36b37a20557d02a5522b832eef63f6848faa431bd40'
AND (
token = 'vg2J02FrueAwiw+Lf/c2kfMFooAp+k5pBrcnzh0MP9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)