UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mBmJvhMs3DyBJ7gGvIwsu6a5d58eiVZFNNKtj+gytug='
WHERE
key_id = '06821323edf8d828f285f5e7d57aece30ae458648cd8ba1c6e3a7cc257b791d4'
AND (
token = 'mBmJvhMs3DyBJ7gGvIwsu6a5d58eiVZFNNKtj+gytug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)