UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9cHxPpCwzrDpRQbkuK/j7GEWxleJa+GwoiE0xypZcaA='
WHERE
key_id = '59a4e884c94b59d5e521ce15b6765e1afddfad5fda0a362257b6804130c8ae19'
AND (
token = '9cHxPpCwzrDpRQbkuK/j7GEWxleJa+GwoiE0xypZcaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)