UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dq42Smy9kkDk/uyjmdBl9Pgi8/jLdUl7w413fzgokv4='
WHERE
key_id = '671fd7631b5d98e2a587980f7355570396d14faeb66875794d89faaaa4213106'
AND (
token = 'dq42Smy9kkDk/uyjmdBl9Pgi8/jLdUl7w413fzgokv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)