UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dQmoVVyvG2hN/QpXwJSNvYd13DjWqXW9aCAoFxolwWY='
WHERE
key_id = 'a6e9db858124e4e03e5b9269f7dfb84a4c3a7e86e6985872d2f4f946187ca695'
AND (
token = 'dQmoVVyvG2hN/QpXwJSNvYd13DjWqXW9aCAoFxolwWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)