UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4jsnnFZBdXg9uu8UYWnTOqDdwCC08NkQgCKgMk07Hh4='
WHERE
key_id = 'a70c7a41738b1597957ba66fd832ab708c2e8fac7fc906acc9c9f7343b6cd6c4'
AND (
token = '4jsnnFZBdXg9uu8UYWnTOqDdwCC08NkQgCKgMk07Hh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)