UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zMnKI7p7PBQbogmLNr9g/oXyPJgkdChDkyCNIxI0PAM='
WHERE
key_id = '126626bf72dc0a241e5c618a51865edc401f5c342e92e81ade8238c077520a5b'
AND (
token = 'zMnKI7p7PBQbogmLNr9g/oXyPJgkdChDkyCNIxI0PAM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)