UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QmJQx7dGNYnhy8/7Re1df1303hmgwUDmYy4Xeap7CFk='
WHERE
key_id = 'a847a3d3c89f8a48ab42272d6ac553bdb0208674ac2299d4b42f9036e17abc1c'
AND (
token = 'QmJQx7dGNYnhy8/7Re1df1303hmgwUDmYy4Xeap7CFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)