UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C0Xn8EeoqQNWEkJ9zy/wA0lrmlz9Pb1zcyM6b7KyIF4='
WHERE
key_id = 'd901ed70010b6be3936d5ac09b7077dd5227681599c1f7dc1b362676d65b8b27'
AND (
token = 'C0Xn8EeoqQNWEkJ9zy/wA0lrmlz9Pb1zcyM6b7KyIF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)