UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Gzl5uUpoCtjNfEwdfo81aeruE6Y1tDfq94Ujl7rwXU='
WHERE
key_id = '009a49251b8b68dcf5b2ada0b8e7412e04aaefcef245dd32ed5e91ff7b47e13a'
AND (
token = '6Gzl5uUpoCtjNfEwdfo81aeruE6Y1tDfq94Ujl7rwXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)