UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CaJa7fjSMdBkldrDqWvSLJgoDdvp75MvDhzTMOLzPeE='
WHERE
key_id = 'a566da64e83927792e42495ebb55a248777b0b89b1c655f8c271246fedcef8aa'
AND (
token = 'CaJa7fjSMdBkldrDqWvSLJgoDdvp75MvDhzTMOLzPeE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)