UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XElYUjtdTNAd8eGM7WNg4E3sg7Xpw64tb1IWh0EFn+4='
WHERE
key_id = 'ac0ee31f93b83f674a0013b66991177c519f4185a527930f30a30bdf1ab8ff24'
AND (
token = 'XElYUjtdTNAd8eGM7WNg4E3sg7Xpw64tb1IWh0EFn+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)