UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H4uv1dlvhMGbPRQkSU4GmbnYwPJsXEotCcnl5M3iHvc='
WHERE
key_id = '00bd52a3f837e2ca308c6d484de3538971ffaffb3cfac9b97b6608fcc0b56a42'
AND (
token = 'H4uv1dlvhMGbPRQkSU4GmbnYwPJsXEotCcnl5M3iHvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)