UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fCHbiF3+ctdwfAOHUdXuBO1mj/wQOSULj2yWNnp08dg='
WHERE
key_id = 'f27c5f2a8e2bd1a6f25f525554c9538aa901b9d07eed202bf46a28fcde02b5d8'
AND (
token = 'fCHbiF3+ctdwfAOHUdXuBO1mj/wQOSULj2yWNnp08dg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)