UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zn2GOjcGliGaH8CpEBxBCHpxF1HCvZI3+vMTcO+XJZc='
WHERE
key_id = '6fde5de919afbde425363bd0625b79fe1e65665e8560b35e410ff254498de620'
AND (
token = 'zn2GOjcGliGaH8CpEBxBCHpxF1HCvZI3+vMTcO+XJZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)