UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZgZKFv2T4BKFEZauAZK5JYprIYCXAFqYquPvwyks29w='
WHERE
key_id = '0c6b5e71d7ee444b3dd018e13c2e675ef92d369e193fa2904807ecd919ae07eb'
AND (
token = 'ZgZKFv2T4BKFEZauAZK5JYprIYCXAFqYquPvwyks29w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)