UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ai05CtcTGOGK/7YH2z23ocmHkbOR/BN7mSqHERe4axw='
WHERE
key_id = 'fb7c5ad1b6b20d53fe8543bfa91218f9013d761d43e507186551578f90256e13'
AND (
token = 'Ai05CtcTGOGK/7YH2z23ocmHkbOR/BN7mSqHERe4axw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)