UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n2fjcckGGUjAYqqslD7KgHQ9Xeh8Ij6B6ih8F6fv92s='
WHERE
key_id = '412b9aa67aeb7a4fb997626cbda1524c2bea54eb9de084428543c3cd1e32c8ee'
AND (
token = 'n2fjcckGGUjAYqqslD7KgHQ9Xeh8Ij6B6ih8F6fv92s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)